<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Using derived metrics in documents</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
p.whs3 { margin-left:0px; }
p.whs4 { margin-left:40px; }
img_whs5 { border:none; width:17px; height:17px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs3 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nCreating and formatting a document\nWorking with metrics and totals in documents\nCreating metrics in documents\nUsing derived metrics in documents");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Using derived metrics in documents </h1>
<p>A derived metric calculates data and displays results dynamically by 
 using at least one of the metrics in the document. Derived metrics add 
 a dynamic application of calculations to a document without requiring 
 new metric definitions. </p>
<p>For example, if your dataset contains the dollar sales for a particular 
 region, and you want to view the same data in millions, you could create 
 a derived metric with a definition of <span class=Code>[Dollar Sales]/1000000</span>.</p>
<p>A derived metric:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>Must be a compound metric; however, a compound metric 
 does not have to be a derived metric</p></li>
	
<li class=p><p>Must use metrics from the same dataset</p></li>
	
<li class=p><p>Can be reused within the document, including in grids 
 and in conditional formatting expressions</p></li>
	
<li class=p><p>Is calculated by the Analytical Engine based on metrics 
 that are contained in Dataset Objects</p></li>
	
<li class=p><p>Cannot use transformation objects</p></li>
</ul>
<p><span style="font-weight: bold;"><B>Note</B></span>: You can only use metrics 
 already existing in a single dataset to create a derived metric. If the 
 new definition demands metric data not readily available, the information 
 cannot be obtained dynamically, as the dataset must first be re-executed. 
 </p>
<p>When you create a derived metric, it is added to the Dataset Objects 
 pane but is not placed on the document. You can add it to the document 
 just as you would any other dataset object. You can also use it in conditional 
 formatting expressions. However, if you select a Grid/Graph object before 
 creating the derived metric, the metric is added to the Grid/Graph as 
 well as placed in the Dataset Objects for future use. </p>
<h2>
<a name="Create derived metric procedure"></a>To create a derived metric 
 in a document</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Open the document in <span style="font-weight: bold;"><B>Design 
 Mode</B></span> or <span style="font-weight: bold;"><B>Editable Mode</B></span>. 
 </p></li>
	
<li class=p><p>Do one of the following:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs3">To 
 create a derived metric in a Grid/Graph: Right-click a Grid/Graph in the 
 document layout area and select<span style="font-weight: bold;"><B> Insert 
 New Metric</B></span>. The Insert New Metric dialog box opens. Continue to 
 the next step.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs3">To 
 create a derived metric directly from a metric in the document: From the 
 Dataset Objects, right-click the metric on which to base the derived metric, 
 and select <span style="font-weight: bold;"><B>Insert New Metric</B></span>. 
 The Insert New Metric dialog box opens. Continue to the next step.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs3">To 
 create a derived metric directly from a metric in the document and base 
 the derived metric on a function: Right-click the metric in the Layout 
 area and select <span style="font-weight: bold;"><B>Insert Function</B></span>. 
 The Insert Function dialog box opens. Then continue with the steps in 
 Creating a derived metric using a function.</p></li>
	</ul>
</ol>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span>: 
 All metrics used in a derived metric must be from the same dataset.</p>
<ol start="3" type="1" class="whs2">
	
<li class=p><p>The Available pane on the left displays objects in the 
 selected dataset. Select the first object to use to define the derived 
 metric and click the <span style="font-weight: bold;"><B>&gt;</B></span> icon. 
 This moves the object to the Definition pane on the right.</p></li>
	
<li class=p><p>Add a function or operator in one of the following ways:</p></li>
</ol>
<ul type="disc" class="whs1">
	<ul type="disc" class="whs1">
		
<li class=p><p>Type an operator such as + or - next to the object 
 name.</p></li>
		
<li class=p><p>You can also use the <span style="font-weight: bold;"><B>Insert 
 Function Wizard</B></span> icon <img src="images/functionwizard.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs5"> to guide you through the process of creating 
 a function. (
<a HREF="Derived_metric_using_function.htm">How</a>?)</p></li>
	</ul>
</ul>
<ol start="5" type="1" class="whs2">
	
<li class=p><p>Select additional objects to define the metric and add 
 them to the Definition pane, or enter a constant.</p></li>
</ol>
<ol start="6" type="1" class="whs2">
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Apply</B></span>. 
 If necessary, modify the expression until it is valid. </p></li>
	
<li class=p><p>In the <span style="font-weight: bold;"><B>Name</B></span> 
 field, type a name for the new metric.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>OK</B></span> to 
 apply the new metric to your document. The new metric is added to the 
 appropriate dataset in Dataset Objects. If you selected a Grid/Graph before 
 creating the metric, it is also added to that Grid/Graph.</p></li>
</ol>
<p>You can now use the derived metric as you would any other dataset object. 
 You can drag and drop it from the Dataset Objects to the Layout area to 
 place it into the document.</p>
<h2>To edit a derived metric</h2>
<ol start="1" type="1" class="whs2">
	
<li class=p><p>Right-click the derived metric in Dataset Objects and 
 select <span style="font-weight: bold;"><B>Edit</B></span>. The Rename/Edit Objects 
 dialog box opens.</p></li>
	
<li class=p><p>Apply any changes you want to make to the metric. You 
 can refer to the previous procedure to make changes in the metric. </p></li>
</ol>
<h2>To delete a derived metric</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Open the document in <span style="font-weight: bold;"><B>Design 
 </B></span>or <span style="font-weight: bold;"><B>Editable Mode</B></span>.</p></li>
	
<li class=p><p>Right-click the derived metric in Dataset Objects and 
 select <span style="font-weight: bold;"><B>Delete From Document</B></span>. </p></li>
</ol>
<h3>Related topics</h3>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Creating_summary_metrics_documents.htm">Creating 
 summary metrics in documents</a></p></li>
	
<li class=p><p>
<a HREF="Creating_metrics_in_documents.htm">Creating 
 metrics in documents</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
